Spring 2024 Course Syllabus Course: ITSW-1304 (Section: N1H, CRN: 11117) Introduction to Spreadsheets

Instructor Information
Instructor	Jennifer Simmons
Email	simmonsja@lamarpa.edu
Phone	(409) 984-6102
Office	Madison Monroe Education - Room: 147A
Office Hours	None
Additional Contact Information
Course Information
Description	Instruction in the concepts, procedures, and application of electronic spreadsheets.
Required Textbooks	Textbook Purchasing Statement: A student attending Lamar State College Port Arthur is not under any obligation to purchase a textbook from the college-affiliated bookstore. The same textbook may also be available from an independent retailer, including an online retailer. Business Information Systems ISBN:978-14-626891-18-0
Additional Materials/Resources	none
Corequisites/Prerequisites	None
Learning Outcomes	Learning Outcomes Upon successful completion of this course, students will: 1.Describe the fundamentals of information technology concepts – hardware, software, security, and privacy. 2.Demonstrate proper file management techniques to manipulate electronic files and folders in local, network, and online environments. 3.Create business documents with word processing software using spelling and grammar check, format and layout, tables, citations, graphics, and mail merge. 4. Create business documents and analyze data with spreadsheet software using (1) tables, sorting, filtering, charts and graphics, privot tables, macros; (2) statistical, financial, logical and look-up functions and formulas; and (3) add-ins. 5.Create business multimedia presentations with presentation software using templates, lists, groups, themes, colors, clip art, pictures, tables, transitions, animation, video, charts, and views. 6.Create databases and manage data with database software using tables, fields, relationships, indexes, keys, views, queries, forms, reports, and import/export functions. 7.Integrate business software applications. 8.Use web-based technologies to conduct ethical business research. 9.Use “goal seeking” and “what-if analysis” to solve problems and make adjustments/recommendations in a business environment.
Program Student Learning Outcomes	Program Outcomes 1. Demonstrates professionalism in the administrative workplace environment. 2. Uses appropriate business administration skills. 3. Uses appropriate office software applications. 4. Creates effective business documents by applying ethical communication practices. 5. Evaluates business documents.
Lecture Topics Outline	01/08 -01/09 Introduction to Excel - Spreadsheets, Vocabulary, Identifying parts of a spreadsheet 01/10 - 01/11 Worksheet Basics and Page Layout: Creating, naming, and saving a workbook.Identifying rows, columns and cell addresses 01/12 - 01/16 Worksheet Basics and Page Layout: Resizing rows and columns, centerting text vertically, wrapping text in a cell, establishing print area 01/17 - 01/18 Worksheet Basics and Page Layout: Inserting and deleting rows, selecting cells, cut, copy, paste 01/19 - 01/22 Worksheet Basics and Page Layout: resizing rows and columns, centering text vertically in cells, freezing panes, renaming a worksheet 01/23 - 01/24 Fourth Six Weeks Test 1 01/25 - 01/26 Formatting data: Format cells, font size, text alignmnet, centering a page, 01/29 - 01/30 Formatting data: Format cells as duration, merge and center, add borders, size, identify type 01/31 -02/01 Formatting data: Format cells by size, fill colors, and font colors 02/02 - 02/05 Numbers and Formulas: Format cells using numbers, decimal values, sort increasing / decreasing values 02/06 - 02/07 Numbers and Formulas: Format cells using numbers, decimal values, sort increasing / decreasing values 02/08 - 02/09 Numbers and Formulas: Sorting data, non adjacent cells,02/12 - 02/13 Numbers and Formulas: Basic formulas 02/14 - 02/16 Fourth Six Weeks Test 2 02/20 - 02/21 Numbers and Formulas: Multi math formulas using parentheses BIM - 1 23-24 Spring Semester Fourth Six Weeks 02/22 - 02/23 Numbers and Formulas: Conditions, amortization, future value, calculate payroll 02/26 - 02/27 Numbers and Formulas: Conditions, amortization, future value, calculate payroll 02/28 - 02/29 Fifth Six Weeks Test 1 03/01 - 03/04 Shapes and Elements: Illustrations, text elements, shapes, multiple worksheets 03/05 -03-06 Shapes and Elements: Illustrations, text elements, shapes, multiple worksheets 03/07 - 03/08 Charts and Graphs: Pie, Line graph, column, bar 03/18 - 03/19 Charts and Graphs: Pie, Line graph, column, bar 03/20 - 03/21 Charts and Graphs: Pie, Line graph, column, bar 03/22 - 03/25 Fifth Six Weeks Test 2 03/26 - 03/27 Power Point: Introduction to Presentations 03/28 - 04/03 Presentation Basics: Creating, text basics, formatting, shapes 04/04 - 04/05 Presentation Basics: Creating, text basics, formatting, shapes 04/08 - 04/09 Customizing Presentations: Shapes, text box, deleting slides 04/10 - 04/12 Customizing Presentations: Shapes, text box, deleting slides 04/15 - 04/16 Enhancing Slide Elements: Images, alignmnet, styles, borders effects, backgrounds 04/17 - 04/18 Enhancing Slide Elements: Images, alignmnet, styles, borders effects, backgrounds 04/19 - 04/22 Sixth Six Weeks Test 1 04/23 - 04/24 Design Themes and Templates 04/25 - 04/26 Design Themes and Templates 04/29 - 04/30 Transitions and Animation 05/01 - 05/02 Transitions and Animation 05/03 - 05/06 Transitions and Animation 05/07 - 05/08 Effective Presentations 05/09 - 05/10 Effective Presentations 04/15 - 04/16 Enhancing Slide Elements: Images, alignmnet, styles, borders effects, backgrounds 04/17 - 04/18 Enhancing Slide Elements: Images, alignmnet, styles, borders effects, backgrounds 04/19 - 04/22 Sixth Six Weeks Test 1 04/23 - 04/24 Design Themes and Templates 04/25 - 04/26 Design Themes and Templates 04/29 - 04/30 Transitions and Animation 05/01 - 05/02 Transitions and Animation 05/03 - 05/06 Transitions and Animation
Major Assignments Schedule	ITSW_1304_76N_202410_P00361487.pdf
Final Exam Date	May 3, 2024 - 8:15 AM   Through  May 3, 2024 - 3:25 PM
Grading Scale	90 - 100=A 80 - 89=B  70 - 79=C   60 - 69=D  Below 59 = F
Determination of Final Grade	Daily - 40% Tests -60%
Course Policies
Instructor Policies	Posted in classroom.
Attendance Policy	Nederland ISD attendance policy
Additional Information
Institutional Policies
MyLSCPA	Be sure to check your campus email and Course Homepage using MyLSCPA campus web portal. You can also access your grades, transcripts, academic advisors, degree progress, and other services through MyLSCPA.
Academic Honesty	Academic honesty is expected from all students, and dishonesty in any form will not be tolerated. Please consult the LSCPA policies (Academic Dishonesty section in the Student Handbook) for consequences of academic dishonesty.
ADA Considerations	The Americans with Disabilities Act (ADA) is a federal anti-discrimination statute that provides comprehensive civil rights for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the the Office for Disability Services Coordinator, Room 231, in the Madison Monroe Building. The phone number is (409) 984-6241.
COVID 19 Information	The Lamar State College Port Arthur (LSCPA) Student Code of Conduct COVID 19 Policy requires students who have been diagnosed with COVID 19 to report their condition directly to their local health department. Students should also contact their course faculty to report their quarantine status. In addition, this policy requires all students to wear face coverings when directly exposed to COVID 19 in compliance with the criteria included in the policy. For more information please refer to the COVID 19 link on the LSCPA website.
Facility Policies	No food or tobacco products are allowed in the classroom. Only students enrolled in the course are allowed in the classroom, except by special instructor permission. Use of electronic devices is prohibited.
HB 2504	This syllabus is part of LSCPA's efforts to comply with Texas House Bill 2504.
Mandatory Reporting of Child Abuse and Neglect	As per Texas law and LSCPA policy, all LSCPA employees, including faculty, are required to report allegations or disclosures of child abuse or neglect to the designated authorities, which may include a local or state law enforcement agency or the Texas Department of Family Protective Services. For more information about mandatory reporting requirements, see LSCPA's Policy and Procedure Manual.
Title IX and Sexual Misconduct	LSCPA is committed to establishing and maintaining an environment that is free from all forms of sex discrimination, including sexual harassment, sexual violence, and other forms of sexual misconduct. All LSCPA employees, including faculty, have the responsibility to report disclosures of sexual misconduct, including sexual harassment, sexual assault (including rape and acquaintance rape), domestic violence, dating violence, relationship violence, or stalking, to LSCPA's Title IX Coordinator, whose role is to coordinate the college's response to sexual misconduct. For more information about Title IX protections, faculty reporting responsibilities, options for confidential reporting, and the resources available for support visit LSCPA's Title IX website.
Clery Act Crime Reporting	For more information about the Clery Act and crime reporting, see the Annual Security & Fire Safety Report and the Campus Security website.
Grievance / Complaint / Concern	If you have a grievance, complaint, or concern about this course that has not been resolved through discussion with the Instructor, please consult the Department Chair.
Department Information	Dual Enrollment Chair: Sheila Guillot Email: guillsr@lamarpa.edu Phone: (409) 984-6381